Registered S3 methods overwritten by 'dbplyr':
method from
print.tbl_lazy
print.tbl_sql
── Attaching packages ───────────────────────────────────────────── tidyverse 1.3.0 ──
✓ ggplot2 3.3.3 ✓ purrr 0.3.4
✓ tibble 3.1.1 ✓ dplyr 1.0.5
✓ tidyr 1.0.3 ✓ stringr 1.4.0
✓ readr 1.3.1 ✓ forcats 0.5.0
── Conflicts ──────────────────────────────────────────────── tidyverse_conflicts() ──
x dplyr::filter() masks stats::filter()
x dplyr::lag() masks stats::lag()
lifetime_earn <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/lifetime_earn.csv')
student_debt <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/student_debt.csv')
retirement <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/retirement.csv')
home_owner <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/home_owner.csv')
race_wealth <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/race_wealth.csv')
income_time <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/income_time.csv')
income_limits <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/income_limits.csv')
income_aggregate <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/income_aggregate.csv')
income_distribution <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/income_distribution.csv')
income_mean <- read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-02-09/income_mean.csv')
The 10 datasets come from the Urban Institute and US Census.
lifetime_earn.csv:
Average lifetime earning by race/gender
| Variable Name | Data Class | Description |
|---|---|---|
| gender | character | gender column |
| race | character | Racial group |
| lifetime_earn | numeric | Lifetime earnings |
student_dept.csv:
Average family student load debt for aged 25-55, by race and year normalized to 2016 dollars.
| Variable Name | Data Class | Description |
|---|---|---|
| year | numeric | Year of measure |
| race | character | Racial group |
| loan_debt | numeric | Loan dept |
| loan_debt_pct | numeric | Share of families with student loan dept |
retirement.csv:
Average family liquid retirement savings normalized to 2016 dollars.
| Variable Name | Data Class | Description |
|---|---|---|
| year | numeric | Year |
| race | character | Racial group |
| retirement | numeric | Retirement dollars |
home_owner.csv:
Home ownership percentage for families.
| Variable Name | Data Class | Description |
|---|---|---|
| year | numeric | Year |
| race | character | Racial group |
| home_owner_pct | numeric | Home ownership by race/ethnicity |
race_wealth.csv:
Family wealth by race/year/measure normalized to 2016, with measures of central tendency with mean and median.
| Variable Name | Data Class | Description |
|---|---|---|
| type | character | Type of measure, either median or mean |
| year | numeric | Year |
| race | character | Racial group |
| wealth_family | numeric | Family wealth |
income_time.csv:
Family-level income by percentile and year.
| Variable Name | Data Class | Description |
|---|---|---|
| year | numeric | Year |
| percentile | character | Income percentile (10th, 50th, 90th) |
| income_family | numeric | Familial income |
income_limits.csv:
Familial income limits for each fifth and top 5% of households by year and race.
| Variable Name | Data Class | Description |
|---|---|---|
| year | numeric | Year |
| race | character | Racial group |
| dollar_type | character | Dollars in that year or normalized to 2019 |
| number | numeric | Number of households by racial group |
| income_quintile | character | Income quintile as well as top 5% |
| income_dollars | numeric | Income in US dollars, specific to dollar type |
income_aggregate.csv:
Share of aggregate income received by each fifth and top 5% of each racial group/household.
| Variable Name | Data Class | Description |
|---|---|---|
| year | numeric | Year |
| race | character | Racial group |
| number | numeric | Number of households by racial group |
| income_quintile | character | Income quintile and/or top 5% |
| income_share | numeric | Income share as a percentage |
income_distribution.csv:
Households by total money income, race, and hispanic origin of householder separated by year and income groups.
| Variable Name | Data Class | Description |
|---|---|---|
| year | numeric | Year |
| race | character | Racial group |
| number | numeric | Number of households |
| income_median | numeric | Income median |
| income_med_moe | numeric | Income median margin of error |
| income_mean | numeric | Income mean |
| income_mean_moe | numeric | Income mean margin of error |
| income_bracket | character | Income bracket (9 total brackets between <$15,000 and >$200,000 |
| income_distribution | numeric | Income distribution as the percentage of each year/racial group - should add up to 100 for a specific year and race |
income_mean.csv:
Mean income received by each fifth and top 5% of each racial group.
| Variable Name | Data Class | Description |
|---|---|---|
| year | numeric | Year |
| race | character | Racial group |
| dollar_type | character | Dollar type, i.e. dollar relative to that year or normalized to 2019 |
| income_quintile | character | Income quintile and/or top 5% |
| income_dollars | numeric | Income dollar average |
Table showing average family wealth by race in 2016
| race | wealth_family |
|---|---|
| White | 919336.1 |
| Hispanic | 191727.3 |
| Black | 139523.1 |
Bar chart showing average family wealth